<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" >
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head><?php 

header('Content-type: text/html; charset=utf-8');
$room_id = $_POST['room_id'];




$mysql_server_name = "localhost";
$mysql_username = "root";
$mysql_password = "root";
$mysql_database = "db_shop";

 $conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
mysql_query ("set names 'utf8'");

    
	
$sql = "select * from room where room_id like '%$room_id%'";
	//require_once('page.php');
	//page($sql,'room.php',"5");//这几句是分页的句子！！
	//$sql = " SELECT * FROM room ORDER BY room_id DESC limit".$begincount.",".$rows; 
      mysql_select_db($mysql_database);
   $result=mysql_query( $sql);

?>

<body><tr>
    <td bordercolor="#FFFFFF"><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#a8c7ce">
	<tr>
        
        <td width="11%" height="20" bgcolor="d3eaef" class="STYLE6"><div align="center"><span class="STYLE10">房间编号</span></div></td>
        <td width="15%" height="20" bgcolor="d3eaef" class="STYLE6"><div align="center"><span class="STYLE10">房间类型</span></div></td>
        <td width="11%" height="20" bgcolor="d3eaef" class="STYLE6"><div align="center"><span class="STYLE10">房间状态</span></div></td>
        <td width="11%" height="20" bgcolor="d3eaef" class="STYLE6"><div align="center"><span class="STYLE10">房间面积</span></div></td>
        <td width="11%" height="20" bgcolor="d3eaef" class="STYLE6"><div align="center"><span class="STYLE10">房间价格</span></div></td>
        
          <td width="35%" height="20" bgcolor="d3eaef" class="STYLE6"><div align="center"><span class="STYLE10">描述</span></div></td>
		  <td width="11%" height="20" bgcolor="d3eaef" class="STYLE6"><div align="center"><span class="STYLE10">操作</span></div></td>
      </tr>
	  
	  <?php
	  while($row =mysql_fetch_array($result,MYSQL_ASSOC))
{

 ?>
  
	<tr>

        <td height="20" bgcolor="#FFFFFF" class="STYLE19"><div align="center"><?php echo $row['room_id'];?></div></td>

		<td height="20" bgcolor="#FFFFFF" class="STYLE19"><div align="center"><?php echo $row['room_type'];?></div></td>

        <td height="20" bgcolor="#FFFFFF" class="STYLE19"><div align="center"><?php echo $row['room_status'];?></div></td>
        <td height="20" bgcolor="#FFFFFF" class="STYLE19"><div align="center"><?php echo $row['room_area'];?></div></td>
        <td height="20" bgcolor="#FFFFFF" class="STYLE19"><div align="center"><?php echo $row['room_cost'];?></div></td>
        <td height="20" bgcolor="#FFFFFF" class="STYLE19"><div align="center"><?php echo $row['description'];?></div></td>
		<td height="20" bgcolor="#FFFFFF" class="STYLE19"><div align="center"><a href="allroomupdate.php?id=<?php echo $row['room_id'];?>">修改</a>&nbsp;<a href="room_delete.php?id=<?php echo $row['room_id'];?>">删除</a></div></td>
      </tr>

	  <?php
	  }
	  ?>
	  
    </table></td>
  </tr>
  <tr> 
	 <td colspan="8" align="center" bgcolor="#FFFFFF"><input name="button" type="button"  value="返回到查询页面" onClick="javascript:window.location='nullroom.php'" /></td>
	</tr>


</body>
</html>
